Monthly Avg Orders Sheet
15
1. R.click on Hourly Avg Orders worksheet and select Duplicate. Rename it as Monthly Avg Orders.
2. Remove Avg Orders Hourly Legend from Marks shelf. Drag and drop Avg Hours Monthly Legend to Colors shelf under Marks.
3.
Remove Order Time from Columns shelf. Drag and drop Order Date to
Columns shelf, right click and select Month from drop down menu.
4. Drag and drop Date Filter to Filters shelf and select only True option.
5. R.click on Y-axis label and select Format. Under Deafult > Font = Tableau Semibold, Size = 10, Dates = Abbreviation.
6. Click on Tooltip under Marks and enter the following:
Month: <MONTH(Order Date)>
Weekday: <WEEKDAY(Order Date)>
Total Sales: <SUM(Total Price)>
Sales MoM: <AGG(Sales MoM %)>
Avg Orders: <AGG(Avg Orders By Day)>
Orders MoM:<AGG(Orders MoM %)>
Avg Price:<AGG(Avg Pizza Price)>
Avg Price MoM:<AGG(Avg Price MoM %)>
Font = Tableau Book, Size = 8, Bold, Alignment = Left
7. Right click on Title and select Edit Title and enter Avg Customer Orders.
Follow the Gif file below for step by step instructions:
Dynamic sheet swapping in Tableau